Master data management

This chapter explains the very limited exceptions to changes to the existing data model. These limited changes were necessary to build a robust solution that does not significantly impact your current work flows

There could be additional changes in future releases.

Customer invoice type

Open: Setup > Sales > Document types > Invoice types

You need to associate each Sage X3 invoice type to the correct invoice type listed in Miscellaneous table 206. 

Common invoice types are 380 (Commercial invoice) and 381 (Credit note).

Supplier invoice type

Open: Setup > Purchasing > Document types > Invoice types

You need to associate each Sage X3 invoice type to the correct invoice type listed in the Miscellaneous table 206.

Common invoice types are 380 (Commercial invoice) and 381 (Credit note).

Company

Open: Setup > Organizational structure > Companies (GESCPY)

The following fields are used in the mapping process to determine the Sage X3 company:

  • Company tax ID no., 9-digit SIREN (CRN) in France

  • EU VAT no.

  • Service ID

Site

Open: Setup > Organizational structure > Sites (GESFCY)

The following fields are used in the mapping process to determine the Sage X3 site:

  • Site tax ID no. (CRN), 14-digit SIRET (CRN) in France

  • Service ID

Business partner

Open: Common data > BPs > Business partners (GESBPR)

Depending on the process, the following fields are used to determine the BP, to trigger the e-invoicing process, or to design the route of the e-invoice: 

On the Identity tab

  • Company name 1 (BPRNAM)

  • SIREN = 9- digit or SIRET = 14-digit (CRN) in France

  • EU VAT no. (EECNUM)

  • Service code and Routing code are used with the SIREN and/or SIRET to direct where to send the e-invoice.

  • Electronic invoice type. This information triggers the e-invoicing process.

  • E-invoicing mapping code. This information links the BP to an XML format to be used.

You can set up exceptions per company, such as adjusting how e-invoicing is managed for each of your companies.

Supplier

Open: Common data > BPs > Suppliers (GESBPS)

The module, Purchasing or A/P-A/R accounting, where to create the invoice transaction defaults from the supplier.

If you choose Manual, the status of the record in the temporary storage table is Incomplete mapping and you need to manually select the destination module.

Currency

Common data > Common tables > Currencies (GESTCU)

The ISO code (ISOCOD) is used to map the currency in Sage X3.

Tax rates

Open: Common data > Common tables > Taxes > Tax rates (GESTVT)

Tax rates need to be updated to populate mandatory information in the XML files:

  • Tax code: list of allowed values in Miscellaneous table 208

  • Exemption reason: if there is an exemption